SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 38530: SUBTRACT adjustments specified in the SAS® Forecast Studio interface are not applied

DetailsHotfixAboutRate It

When a project is created in SAS Forecast Studio and an adjustment variable is specified with a pre- or post-subtraction operation, the underlying PROC HPFENGINE code is not correctly created and the specified adjustment is ignored. This results in forecasts that have not had the subtraction operation(s) applied.

For example, if you have a dependent variable called Y and you specify in the SAS Forecast Studio interface that the variable PRE is to be subtracted from Y prior to modeling and forecasting Y, then SAS Forecast Server creates the underlying ADJUST statement in PROC HPFENGINE as:

adjust y = (pre) / OPERATION=(SUBSTRACT,NONE);

Note that the "SUBTRACT" operator is incorrectly spelled as "SUBSTRACT" in the code generated by SAS Forecast Server. When an unknown pre- or post-adjustment operation is specified in PROC HPFENGINE, the procedure ignores the ADJUST statement with the unrecognized operation and proceeds with the analysis. The resulting forecasts are not computed as expected, since adjustments specified in the ignored ADJUST statements are not applied.

To circumvent the problem, create a new adjustment variable which is equal to the original adjustment variable multiplied by -1. This new adjustment variable can then be specified in the SAS Forecast Studio interface with an addition operation rather than a subtraction operation. All other adjustments not involving a subtraction operation can remain the same as originally specified.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Forecast ServerMicrosoft® Windows® for 64-Bit Itanium-based Systems3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows XP 64-bit Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft® Windows® for x643.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 2003 Standard Edition3.14.19.2 TS2M29.3 TS1M0
Microsoft Windows Server 20083.14.19.2 TS2M29.3 TS1M0
Microsoft Windows XP Professional3.14.19.2 TS2M29.3 TS1M0
Windows 7 Enterprise 32 bit3.14.19.2 TS2M29.3 TS1M0
Windows 7 Enterprise x643.14.19.2 TS2M29.3 TS1M0
Windows 7 Home Premium 32 bit3.14.19.2 TS2M29.3 TS1M0
Windows 7 Home Premium x643.14.19.2 TS2M29.3 TS1M0
Windows 7 Professional 32 bit3.14.19.2 TS2M29.3 TS1M0
Windows 7 Professional x643.14.19.2 TS2M29.3 TS1M0
Windows 7 Ultimate 32 bit3.14.19.2 TS2M29.3 TS1M0
Windows 7 Ultimate x643.14.19.2 TS2M29.3 TS1M0
Windows Vista3.14.19.2 TS2M29.3 TS1M0
64-bit Enabled AIX3.14.19.2 TS2M29.3 TS1M0
64-bit Enabled HP-UX3.14.19.2 TS2M29.3 TS1M0
64-bit Enabled Solaris3.14.19.2 TS2M29.3 TS1M0
HP-UX IPF3.14.19.2 TS2M29.3 TS1M0
Linux3.14.19.2 TS2M29.3 TS1M0
Linux for x643.14.19.2 TS2M29.3 TS1M0
Solaris for x643.14.19.2 TS2M29.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.